<?
include ('../../config/config.php');
$q=mysql_query("SELECT b.NAMA as Nama, p.NAMA_PEKERJAAN as Kerja
FROM pekerjaan as p INNER JOIN biodata as b ON p.NIP = b.NIP WHERE b.NIP = 101");
echo '<table>';
echo '<tr><th>nama</th><th>pekerjaan</th></tr>';
while($r=mysql_fetch_array($q)){
echo '<tr>';
echo '<td>'.$r['Nama'].'</td>';
echo '<td>'.$r['Kerja'].'</td>';
}
echo $r;
?>